/*
 * @Author: AHANG
 * @Date: 2022-04-12 14:34:16
 * @LastEditors: AHANG
 * @LastEditTime: 2022-07-09 15:07:23
 * @Description:
 */
//sqlMap.js
var sqlMap = {
  // 用户
  admin_user: {
    // login: "SELECT * FROM userandpass WHERE user = ? AND pass = ?",
    // add: "insert into userandpass(user,pass) values(?, ?)",
    search: "select * from book",//查询
    delete: "delete from book where id = ?",//删除
    update:
      "update book set author=?,press=?,bookName=?,date=?,price=?,number=? where id =?",//修改
    insert:
      "INSERT INTO book (author,press,bookName,date,price,number) value(?,?,?,?,?,?)",//增加
    login: "SELECT * FROM userandpass WHERE user = ? AND pass = ?",
  },
};
module.exports = sqlMap;
